Tabela LPersonLanguage

Definicja tabeli LPersonLanguage

Name

LPersonLanguage

Code

LPersonLanguage

Comment

PL: Przyporzadkowanie jezyków do osoby
EN: Assignement languages to a person
DE: Die Tabelle fur die Sprachkenntnis


Lista kolumn tabeli LPersonLanguage

Name

Code

PersonID

PersonID

LanguageID

LanguageID

LanguageKnowledgeID

LanguageKnowledgeID

StartDT

StartDT

StopDT

StopDT


Kolumna PersonID tabeli LPersonLanguage

Definicja kolumny PersonID tabeli LPersonLanguage

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LanguageID tabeli LPersonLanguage

Definicja kolumny LanguageID tabeli LPersonLanguage

Name

LanguageID

Code

LanguageID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LanguageKnowledgeID tabeli LPersonLanguage

Definicja kolumny LanguageKnowledgeID tabeli LPersonLanguage

Name

LanguageKnowledgeID

Code

LanguageKnowledgeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LPersonLanguage

Definicja kolumny StartDT tabeli LPersonLanguage

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LPersonLanguage

Definicja kolumny StopDT tabeli LPersonLanguage

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli LPersonLanguage

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPersonLanguage

Definicja klucza Identifier_1 tabeli LPersonLanguage

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment